Alter Table IB_INTERNALBANK
Add IBContraFlag INTEGER default 0
GO
Alter Table IB_INTERNALBANK
Add IBHookPeriod INTEGER default 0
GO
alter table IB_INTERNALBANK
Add IBUnContraMoney DECIMAL(16,2) default 0;
GO
select Count(*) from IB_INTERNALBANK where BillTypeid in (0,4,5)
GO
update IB_INTERNALBANK set IBUnContraMoney=Income where Income<>0 and BillTypeid in (0,4,5)
go
update IB_INTERNALBANK set IBUnContraMoney=Expense where Expense<>0 and BillTypeid in (0,4,5)
go
select Count(*) from IB_INTERNALBANK where IBUnContraMoney<>0